Problem Note 40878: SAS® BI Dashboard has a 1000-row limit for some sources in 4.3 and a default row limit of 10,000 for any data source starting with version 4.3_M2
 |  |  |  |
SAS BI Dashboard limits the number of observations displayed in versions 4.3 and 4.3_M1, and allows the displayed row limit to be configured in later versions. See the appropriate sections below for more details.
SAS BI Dashboard 4.3 and 4.3_M1
In SAS BI Dashboard, when using SAS® Information Maps or tables defined in metadata as the data source for a Data Model, only 1000 observations are included when analyzing the data. There is no indication that your results have been limited to 1000 observations.
To access more than 1000 observations, you can use either an SQL query or a stored process.
SAS BI Dashboard 4.3_M2 and later
Starting with the second maintenance release for BI Dashboard 4.3_M2, the default maximum number of rows returned by any data source is 10,000. If the source data contains more than 10,000 rows, you see an error message about making an adjustment.
If possible, aggregate the data to reduce the number of rows to return. If you must increase the number of observations that are allowed in queries, add the maxRowCount parameter to the appropriate .dsx file. Typically, the value that you specify for maxRowCount should exceed the total number of observations that are returned by data sources at your site.
You can add the maxRowCount parameter and a value to the following DSX files:
- dboard_sas.dsx (for SQL queries)
- infomap.dsx (for information maps)
- omr.dsx (for tables)
- stp.dsx (for stored processes)
Here is an example from the infomap.dsx file where the maxRowCount parameter has been added with a value that specifies a maximum limit of 25,000 observations:
For more information, see the following references.
Note: The reference material for BI Dashboard 4.31 applies to BI Dashboard 4.3_M2.
"Increasing the Limit for Observations from Data Sources" in the SAS 9.3 Intelligence Platform: Web Application Administration Guide, Third Edition
"Working with Data Source XML (.dsx) Files" in the SAS 9.3 Intelligence Platform: Web Application Administration Guide, Third Edition
"Guidelines for Defining Indicator Data" in the SAS BI Dashboard 4.31: User's Guide, Second Edition
Operating System and Release Information
| Product Family | Product | System | Product Release | SAS Release | ||
| Reported | Fixed* | Reported | Fixed* | |||
| SAS System | SAS BI Dashboard | 64-bit Enabled AIX | 4.3 | 4.3_M2 | 9.2 TS2M3 | 9.2 TS2M3 |
| Windows Vista for x64 | 4.3 | 4.3_M2 | 9.2 TS2M3 | 9.2 TS2M3 | ||
| Windows Vista | 4.3 | 4.3_M2 | 9.2 TS2M3 | 9.2 TS2M3 | ||
| Windows 7 Ultimate x64 | 4.3 | 4.3_M2 | 9.2 TS2M3 | 9.2 TS2M3 | ||
| Windows 7 Ultimate 32 bit | 4.3 | 4.3_M2 | 9.2 TS2M3 | 9.2 TS2M3 | ||
| Windows 7 Professional x64 | 4.3 | 4.3_M2 | 9.2 TS2M3 | 9.2 TS2M3 | ||
| Windows 7 Professional 32 bit | 4.3 | 4.3_M2 | 9.2 TS2M3 | 9.2 TS2M3 | ||
| Windows 7 Home Premium x64 | 4.3 | 4.3_M2 | 9.2 TS2M3 | 9.2 TS2M3 | ||
| Windows 7 Home Premium 32 bit | 4.3 | 4.3_M2 | 9.2 TS2M3 | 9.2 TS2M3 | ||
| Windows 7 Enterprise x64 | 4.3 | 4.3_M2 | 9.2 TS2M3 | 9.2 TS2M3 | ||
| Windows 7 Enterprise 32 bit | 4.3 | 4.3_M2 | 9.2 TS2M3 | 9.2 TS2M3 | ||
| Microsoft Windows XP Professional | 4.3 | 4.3_M2 | 9.2 TS2M3 | 9.2 TS2M3 | ||
| Microsoft Windows Server 2008 for x64 | 4.3 | 4.3_M2 | 9.2 TS2M3 | 9.2 TS2M3 | ||
| Microsoft Windows Server 2008 | 4.3 | 4.3_M2 | 9.2 TS2M3 | 9.2 TS2M3 | ||
| Microsoft Windows Server 2003 for x64 | 4.3 | 4.3_M2 | 9.2 TS2M3 | 9.2 TS2M3 | ||
| Microsoft Windows Server 2003 Standard Edition | 4.3 | 4.3_M2 | 9.2 TS2M3 | 9.2 TS2M3 | ||
| Microsoft Windows Server 2003 Enterprise Edition | 4.3 | 4.3_M2 | 9.2 TS2M3 | 9.2 TS2M3 | ||
| Microsoft Windows Server 2003 Datacenter Edition | 4.3 | 4.3_M2 | 9.2 TS2M3 | 9.2 TS2M3 | ||
| Microsoft® Windows® for x64 | 4.3 | 4.3_M2 | 9.2 TS2M3 | 9.2 TS2M3 | ||
| z/OS | 4.3 | 4.3_M2 | 9.2 TS2M3 | 9.2 TS2M3 | ||
| 64-bit Enabled Solaris | 4.3 | 4.3_M2 | 9.2 TS2M3 | 9.2 TS2M3 | ||
| HP-UX IPF | 4.3 | 4.3_M2 | 9.2 TS2M3 | 9.2 TS2M3 | ||
| Linux for x64 | 4.3 | 4.3_M2 | 9.2 TS2M3 | 9.2 TS2M3 | ||
| Solaris for x64 | 4.3 | 4.3_M2 | 9.2 TS2M3 | 9.2 TS2M3 | ||